2012-09-04 - 4661.100 - Enhancement - Combine Shipped and Open Order for New Rep #CrystalReportsSupport

ENHANCEMENT

4661.100 - Combine Shipped + Open order for new rep

Requirement Summary

Need to include Open Revenue, Open Qty and Total Revenue in the existing SA200, SA210, SA215, SA220 and SA230 reports.

Admin Info

Purpose	Including Open Revenue, Qty and Total Revenue to the SA200 series reports.
Requested By	Mark Harris
Spec Created By	Mallareddy D
Spec Created Date	09/04/2012
Spec QA by	Uday Kumar P
Objects	SA200, SA210, SA215, SA220 and SA230 Reports.
Document Status	Complete

References

Prior Tickets

None

Documents

None

Functional Requirement

1. Reports need to be updated to the BW Multiprovider (ZMP_SA_OO) based on BEx queries.
2. Need to include Open Qty and Open Revenue and Total Revenue to the existing queries and reports.
3. Need to remove the "Percent" title from the existing report to accommodate new fields into the reports.
4. Need to remove any additional unused spaces in existing reports.
5. All above changes should be done for SA200, SA210, SA215, SA220 and SA230 reports.
6. Grouping need to be maintained for SA200 report as Region > Sales Org > SBU > Customer.
7. Grouping need to be maintained for SA210 report as Region > Sales Org > Customer.
8. Grouping need to be maintained for SA215 report as Region > Sales Org > Customer Group > Customer.
9. Grouping need to be maintained for SA220 report as Region > Sales Org > Country > Customer.
10. Grouping need to be maintained for SA230 report as Region > Sales Org > License > Team / Silhouette.

Solution Summary

1. Need to include the Open Qty and Open Revenue in BEx queries for the reports.
2. Need to update the report connection with the modified BEx queries.

Test Plan

Validation done by NEC client.

Solution Details

1. Need to create new BEx queries based on the Multiprovider ZMP_SA_OO.
2. Need to update the existing report connection with the modified BEx queries based on above source.

Issues

None